IPC - Using the Motorola Mobility IPC Creator

Click here to view this material in Chinese

 

This information is provided for understanding how our Suppliers will create XML files

 

The Motorola IPC Creator is a spreadsheet based tool for creating an IPC 1752A Homogeneous Material Declaration (Class D) in XML format.  It's basic functions are to load an Motorola XML request header, enter and edit material content information and generate an output XML file suitable for submission to Motorola.

 

The IPC Creator must be run on Microsoft Excel version 2003 Professional SP3 or later.

 

Run the Motorola IPC Creator spreadsheet application - when the Creator tool is first opened, you must accept the disclaimer:

 

 

Information is added to the IPC Homogeneous Material Declaration tab, which uses the data to generate the IPC File.

Screen Overview:

 

  1. Motorola Requestor Information - These fields are automatically populated when an XML Request Header is loaded - Do Not Modify these fields

     

    Do not Modify these fields

     

  2. Supplier Information - These fields are populated automatically when an XML Request Header is loaded

     

    You may edit these fields as necessary, however If any of these fields are incorrect, please notify Motorola so corrections can be applied in the system

     

  3. Requestor Company - This field shall be populated automatically when an XML Request Header is loaded with Motorola Mobility

  4. Part Usage - This field shall be populated automatically with MD when an XML Request Header is loaded.

     

    When loading an XML Header or File, Part Usage will be automatically assigned. If it is not, please assign by typing MD into the field

     

  5. Load XML Header Button - Opens a Windows File Open dialog box, allowing the user to navigate to and select a previously stored Header file to load

  6. Load XML File Button - Opens a Windows File Open dialog box, allowing the user to load an existing XML file for modification if desired

     

    This will only load 1752A class D compatible XML files

     

  7. Response Date - Enter the date of this submittal using a normal date formatted entry (MM/DD/YYYY)

  8. Generate Declaration - Opens a Windows file Save-As dialog box and allows the user to navigate to an appropriate folder for storing the declaration.  Note that the file name is already present and should not be altered.  Altering the file name may result in processing delays

  9. Supplier Acceptance - Use the drop down list to select Accepted or Not Accepted

     

    If this field is not equal to Accepted the XML file will not be generated

     

  10. Legal Declaration - Standard IPC legal text for a material content declaration.  This may not be edited

  11. Part and Material Area - Motorola part number, description and Supplier part number will be populated automatically from the header
    All other fields must be completed as part of the material declaration process described below

  12. Run Error Check - Checks the entered data for various errors prior to generation of an XML file. See error messages and guidance below

Steps to Completing a Material Declaration

The Motorola request for environmental data email contains a Zip file attachment.  This file contains one or more IPC 1752A XML header files depending on how many parts data is being requested for.  Save these XML file(s) to a suitable folder on your computer

Load a File header

  1. Press the Load XML File button (F above), and use the File Open dialog, navigate to and select the file for opening. The file can be modified as necessary
     

     

    This will only load 1752A class D compatible XML files

     

Load a Request header

  1.  Press the Load XML Header button (E above), and use the File Open dialog, navigate to and select the file for opening. After successfully loading the Header, the screen should appear as follows:

     

  2.  Complete the pink highlighted fields. If any supplier fields are highlighted enter correct information in those cells as well

    The Contact Name should reflect the name of the person filling in the W18 report, please modify as necessary

    The Supplier Information must not be changed

 

  1.  Verify that the Motorola item number, Supplier part number, Supplier Company ID and Supplier Company Name are correct

    If any of these do not match, contact Motorola to have these corrected and a new request will be sent.  Do not change these fields as they must match exactly the values in the system. Changes to these fields will result in an automatic rejection of the file

 

  1.  The Product Units are defaulted to Each which is the most common. This may be changed by using the drop down list for that cell

  2.  Fill in the Supplier Part Description

  1.  Fill in the Supplier Part Mass amount and using the drop down list select the appropriate Mass Units (g, mg, ug, kg)

Entering Material Data

There are four use cases described below for entering material data: Components and Simple Declarations, Complex Items, Motorola BOM Controlled Parts and ODM Parts

General rules for the material data section

  1.  Row 11 must contain the Motorola and Supplier part information. No other fields should be used for that row.

  2.  For all other rows, only one section type may be used in any row. For example, if adding subparts then only the subpart section must contain data, for materials, only the material section, etc.

  3.  The order of entry for the sections is as follows (note, if subparts are not used, the first material will follow the product row):
        Product/Supplier section
             Supplier subpart Section (if used)
                   Material Section
                       Substance section

  4.  The sum of all substances in a material must be between 99 and 100%

  5.  The sum of all material weight must equal the subpart weight (if used) or the Product weight (if subparts are not used)

  6.  The sum of all subpart weights (if used) must equal the product weight

     

    For items 4, 5 and 6, there is a small tolerance allowed in the error checking. However it is recommended that exact values be used to reduce chances or rejection due to any of these cases

 

  1.  Duplicate subpart names are not allowed in a product

  2.  Duplicate Material names are not allowed in a subpart (if used) or a product (if subparts are not used)

  3.  Duplicate CAS#'s are not allowed in any one material. This includes the use of SYSTEM as a CAS#'s

  4.  Duplicate material names ARE allowed in different subparts and duplicate CAS#'s ARE allowed in different materials

 

Entering Material Declaration for Specific Types of Parts

IPC - Material Data Entry for a Single Component or Simple Part
IPC - Material Data Entry for Complex Assemblies (Using Subparts)

IPC - Material Declaration Entry for Motorola Controlled BOM Declarations

IPC - Material Declaration Entry for ODM Products

Generate an IPC XML Declaration for submission

  1.  Click the Generate Declaration button ( G above). A number of error checks will be performed, and notification provided if required fields are missing data or contain incorrect data type. If all error checks passed, the following dialog box will be displayed:

  2.  If supporting documentation is being sent in addition to the declaration press Yes  otherwise press No. This adds text to the filename to allow Motorola to search for appropriate documents in the supporting documents email box

  3.  A Windows File Save-As dialog box will be displayed allowing navigation to an appropriate folder for saving and click Save

     

    Do not change the file name.  It is constructed to allow efficient processing of incoming files and changes may result in processing delays or being ignored by the system

 

  1.  Additional error checks will be performed for the sum of substance percentage, sum of material weights and sum of subpart weight.  If an error is displayed, see below for guidance on resolution.  If all error checks pass then the following message box will be displayed indicating completion and reminders for email submittal of declaration and supporting documents:

 

Submit declaration and supporting documents

  1.  After successful completion of an IPC XML declaration, please email the declaration to the automated processing email address:
    WPAsubmittal@lenovo.com

  2.  If supporting documents are required ( for > 10% undeclared materials, reports, MSDS's etc.) or for general correspondence, please email these to the EDM you normally correspond with, or if unsure use: Environmentaldata@motorola.com
    To avoid delays in processing include Document_Mfg name_Motorola item number in the email subject when sending supporting documents

    Only valid XML declarations or zipped declarations will be processed by the WPAsubmittal email box. All other files will be ignored. Please be sure to use the appropriate mail addresses

 

Control for Supporting Documents

  1. Material name - For materials needing supporting documents, the material name must include below information:

Supporting Document

Homogeneous Material

Example

No supporting document

Location_Component_Material name

FH_Ni-Plating

MSDS or IP form

Location_Component_Material name [raw material manufacturer name _ material trade name]

FH_Ni-Plating_[Ablebond 9830]

Test report

Location_Component_Material name [EN1811/ASTM/other test name_MIN]

FH_Ni-Plating [EN1811_01000000000];

FH_Ni-Plating [ASTM_01000000000]

Waiver email

Location_Component_Material name [Waiver_MIN]

FH_Ni-plating [Wavier_0100000000]

 

  1. Supporting document name: follow the table for different supporting documents
     

Supporting Document Type

Document Title

MSDS or IP form

raw material manufacturer name _ material trade name

ODM BOM

BOM_MIN

Test report

EN1811_MIN; ASTM_MIN; ROHS_MIN, etc

Waiver email: saved as PDF file

Waiver_MIN

 

  1. Supporting Documents can be sent directly to the contact EDM if known. If not, contact Environmentaldata@motorola.com

  2. For parts with same material criteria, one test report can cover all parts. Test reports need only be submitted one time. For subsequent similar part submissions, simply note the test report name and tested part number in the material name

  3. IP forms and MSDS need only be submitted one time for a specific material

Tips and Tricks

  1. In order to allow the most editing flexibility in the tool most cut and paste functionality is available for use. However, it is highly recommended that when pasting into the sheet only Paste-Special-Values is used to preserve proper formatting.

  1.  If cell formatting gets changed by drag-drop or pasting from other sheets it may be restored by selecting an undamaged row and using the format painter to repaint the impacted rows. This will restore formatting while not changing the data already entered.

  2.  To save file space The sheet comes with only 200 rows formatted for use. To add more rows select a row in the formatted area and insert as many new rows as required. These new rows will have the same drop downs and formatting as the ones above it.

  3.  While there are a number of checks for valid CAS#'s, sum of weight etc., there are no checks for duplicate material names, subpart names or CAS#'s. Please review prior to submittal.

  4.  Overlapping sections will usually result in weight sum errors. Each of the four sections (Motorola/Supplier part, subpart, material and substance) must be on separate rows and constructed in the correct order as shown in the examples.

  5.  Row 11 must contain the Motorola Item and Supplier Part information. No other fields on the row should be filled in

Error checking and messages

Error checks are performed each time a file is generated. It may also be run at any time by pressing the Run Error Check button (K above). Note if this is run before completion of material data there will always be errors reported however, it is still useful while creating large declaration to check data that has already been entered

 

The following error messages may generated by the application accompanied by suggested corrections

 

File does not contain sufficient IPC header information.  Aborting!

File is missing critical information such as Motorola item number or supplier part number.  Contact Motorola and request a new header file

Please complete required fields: Enter Part usage = HOME or MD, Enter response date and Enter Supplier Acceptance = Accepted

Complete indicated required fields

Please complete required fields in Requestor and Supplier Sections.  Aborting!

Complete indicated required fields

Please complete required fields on row 11.  Aborting!

Missing Supplier Part name, Mass amount or Mass units, enter required information

Response date must be a valid date.  Please enter a valid date using mm/dd/yy or yyyy/mm/dd format.  Aborting!

Data entered is not recognized as a valid date.  Enter a valid date using mm/dd/yy format.

Request date must be a valid date.  Please enter a valid date using mm/dd/yy or mm/dd/yyyy format.  Aborting!

Data entered is not recognized as a valid date.  Enter a valid date using mm/dd/yy format.

Respond by date must be a valid date.  Please enter a valid date using mm/dd/yy or mm/dd/yyyy format.  Aborting!

Data entered is not recognized as a valid date.  Enter a valid date using mm/dd/yy format.

Request date must be a valid date.  Aborting!

 Usually caused by text in the date field.  Enter a valid date

Respond by date must be a valid date.  Aborting!

 Usually caused by text in the date field.  Enter a valid date

Response date must be a valid date.  Aborting!

 Usually caused by text in the date field.  Enter a valid date

Response date cannot be later than today or more than 90 days in the past.  Please enter a valid date using mm/dd/yy or mm/dd/yyyy format.  Aborting!

Caused when entered date is more that 90 days in the past or sometime in the future.  Enter today‚Äôs date in the correct format mm/dd/yy.

No product found in first row.  Aborting!

Missing Product information.  Load or reload header file

No Subpart or material found at row NN . Aborting!

A subpart or material was expected at row NN.  Check to verify proper construction

No material found at row NN. Aborting!

A material was expected at row NN.  Check to verify proper construction

No Substance found at row NN. Aborting!

A Substance was expected at row NN.  Check to verify proper construction

No CAS number found at row NN. Aborting!

Verify a CAS# exists in row NN

Invalid CAS number found at row NN. Aborting!

Indicates that the CAS# is not valid, check CAS#

SYSTEM CAS# declared but substance name is not equal to exactly "MISC., NOT TO DECLARE"  at row NN. Aborting!

Verify CAS# = "SYSTEM" and substance name = "MISC., NOT TO DECLARE"  this text must be exactly as shown here

Sum of substances can not exceed 100% at row NN. Aborting!
Sum of substances can not be less than 99% at row NN. Aborting!

The sum of substance % in each material must be between 99 and 100%.  Row NN indicates the last substance in the material being checked.  Verify sum is 99-100%

Sum of material weights can not exceed 101% of subpart weight at row NN. Aborting!

Sum of material weights can not be less than 99% of subpart weight at row NN. Aborting!

The sum of all material weights in a subpart between 99 and 101% of the subpart weight.  Row NN indicates the last substance in the subpart being checked.  Verify that the sum of weights of all materials in subpart are 99-101% of the subpart weight
Note
: The Entered and Calculated values are displayed in the error message box

Product weight cannot be less than 91% of the sum of subpart weights at row NN. Aborting!

Product weight cannot exceed the sum of subpart weights by more than 9% at row NN. Aborting!

The entered Product weight (cell(F11)) must be between 91 and 109% of the sum of all subpart weights multiplied by each subpart quantity.  Row NN indicates the last substance in the Product being checked.  Verify that the Product weight is between 91 and 109% of the sum of weights of each subpart*QTY
Note
: The Entered and Calculated values are displayed in the error message box

Product weight cannot be less than 91% of the sum of material weights at row NN. Aborting!

Product weight cannot exceed the sum of material weights by more than 9% at row NN. Aborting!

Subparts are not used.  The entered Product weight, cell(F11),  must be between 91 and 109% of the sum of all material weights.  Row NN indicates the last substance in the Product being checked.  Verify that the Product weight is between 91 and 109% of the sum of material weights
Note
: The Entered and Calculated values are displayed in the error message box

Unknown units for Product/material/subpart weight at row , NN, must be g, mg or kg.  Aborting!

Units for Product subparts and material must be g, mg, or kg only.  Check to verify valid units are entered

Error # was generated by WindowsModule Windows Error Description at row NN.

Other Windows or Excel generated errors may occur.  These normally have to do with invalid filenames, paths, folder permissions or file permissions.  Check these and any other information in the error message to correct the problem

Only product information allowed in row 11, please remove or move subpart, material or substance data from this row.  Aborting!

Row 11 is only allowed to contain data in the product section.   Check row 11 to make sure only product information is entered and no data is entered for the subpart, material or substance sections.

Product, Subpart, Material and Substance data must be on separate rows at row NN, please check the data on this row.  Aborting!

Data is only allowed to be in one section (Product, Subpart, Material or Substance) per row.  Check row NN to make sure only one section contains data.

No Subpart Quantity found at row NN. Aborting!

Quantity is a required field if subparts are declared.  Enter valid quantity at row NN.

Space found in CAS number found at row NN. Aborting!

CAS Number cells may not contain spaces.  Check CAS number at row NN.

Additional data was found below the last valid row at row NN, please check the data in this row.  Aborting!

Entries were detected beyond the end of the declaration.  Check row NN for valid data.

Duplicated SubPart in row NN.  Aborting!

SubPart names are only allowed to be declared once per product.  Change the Subpart name at row NN.

Duplicated Material in row NN for SubPart Subpartname.  Aborting!

Material names are only allowed to be declared once per SubPart.  Change the material name at row NN.

Duplicated Substance in material materialname, row NN. Aborting!

Substances are only allowed to be declared once per material.  Check the substance at row NN.